﻿/*
数据库修改及服务器数据库版本
201205300640034_UpdateSightVouchNum.cs
201205310306436_AddSightVersionUpdateRoleMenuCss.cs
201206110447202_UpdateAutoPush.cs
201206140451180_UpdateTourSightDay.cs
201206190533038_AddAdvertise.cs
201207020425514_UpdateAutoPushExpireDateTime.cs
*/
---------------------------------------------------------------------------------------------------------------
/*
页面修改
added by yjihrp 2012.7.2.10.27
View/Tour/_Form.cshtml				隐藏了，线路自定义时间
View/Tour/Index.cshtml				隐藏了，线路自定义时间
View/Tour/TourDetailIndex.cshtml	修改了返回按钮链接
View/Sight/Index.cshtml				注释掉，导出数据按钮
View/Sight/Detail.cshtml			注释掉,景点商品列表按钮
end added by yjihrp 2012.7.2.10.27

added by yjihrp 2012.7.3.10.36
View/Push/AutoPushIndex.cshtml		定时内容过期显示红色
end added by yjihrp 2012.7.3.10.36
*/
---------------------------------------------------------------------------------------------------------------
/*
存在问题
added by yjihrp 2012.7.3.10.35
1、景点关联到路线的
2、推送内容关联到定时推送的
end added by yjihrp 2012.7.3.10.35
*/
---------------------------------------------------------------------------------------------------------------
--日程表还没有同步到项目中的
--清空初始化数据
truncate table [EntityDbContext].[dbo].[User]
truncate table [EntityDbContext].[dbo].[UserRole]
truncate table [EntityDbContext].[dbo].[Role]
truncate table [EntityDbContext].[dbo].[PicThumbSize]
truncate table [EntityDbContext].[dbo].[PicClass]
truncate table [EntityDbContext].[dbo].[SightPointArea]
truncate table [EntityDbContext].[dbo].SightPointClass
truncate table [EntityDbContext].[dbo].ArticleClass

--清空所有权限
truncate table [EntityDbContext].[dbo].MvcAction
truncate table [EntityDbContext].[dbo].MvcController
truncate table [EntityDbContext].[dbo].[MvcRolePermission]
--end 清空所有权限

--清空权限分类 action controller
truncate table [EntityDbContext].[dbo].MvcActionClass
truncate table [EntityDbContext].[dbo].MvcControllerClassx
--end 清空权限分类 action controller

--end 清空初始化数据
select * from [EntityDbContext].[dbo].[User]
select * from [EntityDbContext].[dbo].[UserRole]
select * from [EntityDbContext].[dbo].[Role]


select * from [EntityDbContext].[dbo].[PicThumbSize]
select * from [EntityDbContext].[dbo].[PicClass]


select * from [EntityDbContext].[dbo].[SightPointArea]
select * from [EntityDbContext].[dbo].SightPointClass


select * from [EntityDbContext].[dbo].ArticleClass


select * from [EntityDbContext].[dbo].MvcActionClass
select * from [EntityDbContext].[dbo].MvcControllerClass


select * from [EntityDbContext].[dbo].MvcAction
select * from [EntityDbContext].[dbo].MvcController
select * from [EntityDbContext].[dbo].[MvcRolePermission]

